Data incremented not copied using fill handle due to data is incremental.
Cause:
The selected data is incremental and the AutoFill feature allows Excel to increment the data automatically.
Solution:
Select the original data again. Press and hold down CTRL while dragging the fill handle.
1) Select the cell(s) containing the original data.
2) Press and hold down CTRL.
3) Drag the fill handle over the desired range.
The fill handle
